Introduction:
The purpose of this report is to conduct a sales data analysis of Kevin Cookie Company for the period between 2019 and 2020. The analysis was conducted using methods such as pivot charts, data visualization, and statistical analysis.
Key Findings:
• Increased annual revenue from 2019 to 2020
• The grand total revenue worldwide in the span of 2019-2020 is $ 4,690,319
• India was the highest revenue generating country.
• During the observed period, the month of October recorded the highest number of units sold, consequently resulting in the highest profit for the month.
• Chocolate Chip Cookie is the best seller throughout the years.
Analysis and Interpretation:
• Annual revenue for 2020 is 54% higher than 2019 at 24%.
• India is the most profitable market, accounting for 23.12% of global sales
• The increase in annual revenue, profit and volume from 2019 to 2020 can be attributed to the pandemic period when people were stocking up on food.
• The analysis indicates that the highest monthly sales volume was observed towards the end of the year, owing to seasonal holidays such as Halloween and Christmas.
• Chocolate Chip Cookie emerged as the best-selling and most profitable product in all countries under consideration, while Fortune Cookie registered the weakest performance. These findings were consistent across all countries, as well as globally.
Conclusions and Recommendations:
• Our analysis suggests that the Chocolate Chip Cookie is a strong performer and presents an opportunity to further increase sales. As such, we recommend that the company prioritize this product in its future strategies.
• Our findings indicate that end-of-year holidays such as Christmas and Halloween offer a significant potential for driving sales. Thus, we recommend that the company focus on promotional drives during this period to capitalize on this opportunity.
• An additional recommendation for the company to maximize sales during the holidays is to introduce holiday-themed bundles and/or offer products with holiday-related packaging.
• To maintain sales, it is crucial for the company to offer its top-performing product in all countries.
• To improve sales performance for low-performing products, the company may consider increasing advertising efforts for these products.
Limitations:
• The dataset used for this analysis is fictitious and was obtained from Kevin Stratvert.
• As the data is limited to a 2-year period, it may not accurately predict future trends or performance.
• The provided dataset includes only certain data points and may not be able to provide insights for all possible statistical questions that could aid the company in achieving its objectives.